package xjtu.se.articlecommunity.user.login.dao;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import xjtu.se.articlecommunity.user.login.dto.ULoginDto;

public interface ULoginDao {
    @Select("select count(*) from t_user where ( u_mail=#{u_key} or u_id=#{u_key} or u_tel=#{u_key} ) and u_passwd=#{password}")
    int findCountByID(ULoginDto dto);
    @Select("select count(*) from t_user where ( u_mail=#{u_key} or u_id=#{u_key} or u_tel=#{u_key} ) and u_status=-1")
    int ifBanedUser(@Param("u_key") String u_key);
}
